#!/usr/bin/env python3
# -*- coding: utf-8 -*-

CREATE_DB_STATUS_SCRIPT = '''
    CREATE TABLE dbstatus (
        inited          BOOLEAN,
        modification    DATE);
    INSERT INTO dbstatus VALUES (1, "1921-12-7");
'''

CRTEAT_TRADER_INFO_TABLE = '''
    CREATE TABLE traders (
        id INT UNIQUE,
        passwd TEXT)  
'''

CRTEAT_TRADER_REQUEST_TABLE_SCRIPT = '''
    CREATE TABLE trader_req_0 (
        stockname TEXT,
        price INT,
        quantity INT);
    CREATE TABLE trader_req_1 (
        stockname TEXT,
        price INT,
        quantity INT);
    CREATE TABLE trader_req_2 (
        stockname TEXT,
        price INT,
        quantity INT);
    CREATE TABLE trader_req_3 (
        stockname TEXT,
        price INT,
        quantity INT);
'''

INSERT_DEFAULT_TARDERS_SCRIPT = '''
    INSERT INTO traders VALUES (1121, '123456');
    INSERT INTO traders VALUES (1038, '123456');
    INSERT INTO traders VALUES (3728, '123456');
    INSERT INTO traders VALUES (6901, '123456');
    INSERT INTO traders VALUES (7224, '123456');
'''
